home *** CD-ROM | disk | FTP | other *** search
/ Amiga Format CD 46 / Amiga Format CD46 (1999-10-20)(Future Publishing)(GB)[!][issue 1999-12].iso / -serious- / misc / fondscalc / english / fondscalc.slk next >
Text File  |  1999-09-06  |  4KB  |  185 lines
  1. ID;PTurboCalc;N
  2. B;Y23;X13
  3. O;L;C
  4. F;W1 256 10
  5. F;SD
  6. C;Y1;X1;K"Performance of the value for the Fonds XX (Corporation XX) at the Depot XX"
  7. F;SD
  8. C;Y3;X1;K"Shares"
  9. F;SD
  10. C;X2;K"Value by "
  11. F;SD
  12. C;X3;K"calling"
  13. F;SD
  14. C;X4;K"Actual "
  15. F;SD
  16. C;X5;K"Value"
  17. F;SD
  18. C;X6;K"Diffe"
  19. F;SD
  20. C;X7;K"rence"
  21. F;SD
  22. C;X8;K"Date of call"
  23. F;SD
  24. C;X9;K"Actual Date"
  25. F;SD
  26. C;X10;K"Difference "
  27. F;SD
  28. C;X11;K"per year"
  29. F;SD
  30. C;X12;K"Profit"
  31. F;SD
  32. C;X13;K"yearly interest rate"
  33. C;Y5;X1;K10
  34. C;X2;K50;E50
  35. F;SD
  36. C;X3;K"  EUR"
  37. C;X4;K51.5
  38. F;SD
  39. C;X5;K"  EUR";ER5C3
  40. C;X6;K1.5;ERC4-RC[-4]
  41. F;SD
  42. C;X7;K"  EUR";ER5C3
  43. C;X8;K"03.01.1999"
  44. C;X9;K"27.06.1999";ETODAY()
  45. C;X10;K3.1285714285714;ERC[-4]*365/(R5C[-1]-RC[-2])
  46. F;SD
  47. C;X11;K"  EUR";ER5C3
  48. C;X12;K0.020476509176189;ER[17]C[-6]/R[17]C[-10]-1-(R[15]C[-3]*(INT((RC[-3]-RC[-4])*R[16]C[-3]/365)+1)+R[15]C[-2]*(INT((RC[-3]-RC[-4])*R[16]C[-2]/365)+1))
  49. C;X13;K0.056772666091226;E(LRATE(RC[-12]*RC[-11],R[17]C[-7]*RC[-12]/(RC[-12]+R[3]C[-12]+R[6]C[-12]),(RC[-4]-RC[-5])/365)*RC[-12]+LRATE(R[3]C[-12]*R[3]C[-11],R[17]C[-7]*R[3]C[-12]/(RC[-12]+R[3]C[-12]+R[6]C[-12]),(RC[-4]-R[3]C[-5])/365)*R[3]C[-12]+LRATE(R[6]C[-12]*R[6]C[-11],R[17]C[-7]*R[6]C[-12]/(RC[-12]+R[3]C[-12]+R[6]C[-12]),(RC[-4]-R[6]C[-5])/365)*R[6]C[-12])/(RC[-12]+R[3]C[-12]+R[6]C[-12])-(R[15]C[-4]*R[16]C[-4]+R[15]C[-3]*R[16]C[-3])
  50. C;Y6;X2;K97.7915;ER[-1]C*R20C[11]
  51. F;SD
  52. C;X3;K"  DM"
  53. C;X4;K100.725245;ER[-1]C*R[14]C[9]
  54. F;SD
  55. C;X5;K"  DM";ER6C3
  56. C;X6;K2.933745;ER6C[-2]-RC[-4]
  57. F;SD
  58. C;X7;K"  DM";ER6C3
  59. C;X8;K""
  60. C;X10;K6.1189538571429;ERC[-4]*365/(R5C[-1]-R[-1]C[-2])
  61. F;SD
  62. C;X11;K"  DM";ER6C3
  63. C;X12;K""
  64. C;X13;K""
  65. C;Y7;X2;K""
  66. C;X6;K""
  67. C;X7;K""
  68. C;Y8;X1;K5
  69. C;X2;K50.35
  70. F;SD
  71. C;X3;K"  EUR";ER5C3
  72. F;SD
  73. C;X5;K""
  74. C;X6;K1.15;ER5C[-2]-RC[-4]
  75. F;SD
  76. C;X7;K"  EUR";ER5C3
  77. C;X8;K"03.03.1999"
  78. C;X10;K""
  79. C;Y9;X2;K98.4760405;ER[-1]C*R20C[11]
  80. F;SD
  81. C;X3;K"  DM";ER6C3
  82. F;SD
  83. C;X5;K""
  84. C;X6;K2.2492045;ER6C[-2]-RC[-4]
  85. F;SD
  86. C;X7;K"  DM";ER6C3
  87. C;X10;K""
  88. C;Y10;X2;K""
  89. C;X6;K""
  90. C;X7;K""
  91. C;Y11;X1;K3
  92. C;X2;K50.74
  93. F;SD
  94. C;X3;K"  EUR";ER5C3
  95. F;SD
  96. C;X5;K""
  97. C;X6;K0.76000000000001;ER5C[-2]-RC[-4]
  98. F;SD
  99. C;X7;K"  EUR";ER5C3
  100. C;X8;K"03.04.1999"
  101. C;X10;K""
  102. C;Y12;X2;K99.2388142;ER[-1]C*R20C[11]
  103. F;SD
  104. C;X3;K"  DM";ER6C3
  105. F;SD
  106. C;X5;K""
  107. C;X6;K1.4864308;ER6C[-2]-RC[-4]
  108. F;SD
  109. C;X7;K"  DM";ER6C3
  110. C;X10;K""
  111. C;Y13;X13;K""
  112. F;SD
  113. C;Y14;X1;K"acquired shares"
  114. C;Y16;X1;K0
  115. F;SLTD
  116. C;Y19;X2;K"Total "
  117. F;SRTD
  118. C;X3;K"stake"
  119. F;STD
  120. C;X4;K"Actual "
  121. F;SRTD
  122. C;X5;K"stock"
  123. F;STD
  124. C;X6;K"after tax"
  125. F;SRTD
  126. C;X7;K"ation"
  127. F;SD
  128. C;X9;K"Costs of the depot"
  129. F;SD
  130. C;X10;K"Costs for managing"
  131. F;SD
  132. C;X12;K"Tax rate"
  133. F;SD
  134. C;X13;K"Exchange value"
  135. F;SL
  136. C;Y20;X2;K""
  137. F;SR
  138. C;X3;K""
  139. C;X4;K""
  140. F;SR
  141. C;X5;K""
  142. C;X6;K""
  143. F;SR
  144. C;X7;K""
  145. C;X9;K0.00125
  146. C;X10;K0.00125
  147. C;X12;K0.305
  148. C;X13;K1.95583
  149. F;SL
  150. C;Y21;X2;K""
  151. F;SR
  152. C;X3;K""
  153. C;X4;K""
  154. F;SR
  155. C;X5;K""
  156. C;X6;K""
  157. F;SR
  158. C;X7;K""
  159. C;X9;K4
  160. C;X10;K4
  161. C;X12;K999
  162. F;SL
  163. C;Y22;X2;K903.97;ER5C1*R[-17]C+R8C1*R[-14]C+R11C1*R[-11]C
  164. F;SRD
  165. C;X3;K"  EUR";ER5C3
  166. C;X4;K927;E(R5C1+R8C1+R11C1+R16C1)*R[-17]C
  167. F;SRD
  168. C;X5;K"  EUR";ER5C3
  169. C;X6;K927;EIF((R[1]C[-2]-R[1]C[-4])>R[-1]C[6],RC[-2]-(RC[-2]-RC[-4])*R20C[6],RC[-2])
  170. F;SRD
  171. C;X7;K"  EUR";ER5C3
  172. F;SLB
  173. C;Y23;X2;K1768.0116451;ER5C1*R[-17]C+R8C1*R[-14]C+R11C1*R[-11]C
  174. F;SRBD
  175. C;X3;K"  DM";ER6C3
  176. F;SB
  177. C;X4;K1813.05441;E(R5C1+R8C1+R11C1+R16C1)*R[-17]C
  178. F;SRBD
  179. C;X5;K"  DM";ER6C3
  180. F;SB
  181. C;X6;K1813.05441;EIF((RC[-2]-RC[-4])>R[-2]C[6],RC[-2]-(RC[-2]-RC[-4])*R20C[6],RC[-2])
  182. F;SRBD
  183. C;X7;K"  DM";ER6C3
  184. E
  185.